Software:Oracle Database

From HandWiki
Short description: Proprietary database management system
Oracle Database
Oracle logo.svg
Developer(s)Oracle Corporation
Initial release1979; 45 years ago (1979)
Stable release
Written inAssembly language, C, C++[1]
TypeMulti-model database
LicenseProprietary[2]
Websitewww.oracle.com/database/

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model[3] database management system produced and marketed by Oracle Corporation.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-prem, on-cloud, or as a hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-prem, on Oracle Cloud or at Cloud at Customer).[4]

Oracle Database uses SQL query language for database updating and retrieval.[5]

History

Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex.[6]

Releases and versions

Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for "Cloud". Previous releases (e.g. Oracle Database 10g and Oracle9i Database) have used suffixes of "g" and "i" which stand for "Grid" and "Internet" respectively. Prior to the release of Oracle8i Database, no suffixes featured in Oracle Database naming conventions. There was no v1 of Oracle Database, as co-founder Larry Ellison "knew no one would want to buy version 1".[7]

Oracle Database release numbering has used the following codes:

{{{2}}}
Oracle
Database
Version
Initial
Release
Version
Initial
Release
Date
Terminal
Patchset / RU
Version
Terminal
Patchset / RU
Date
Marquee
Features
Oracle Database 23c 23.2.0 April 2023 (Linux) Oracle Database Free - Developer Release[8]

September 2023 Oracle Database on Base Database Service[9]

JSON Relational Duality, JSON Schema Validation, Transactional Microservices Support, OKafka, Operational Property Graphs, Support for SQL/PGQ, Schema Privileges, Developer Role, SQL Firewall, TLS 1.3 Support, Integration with Azure Active Directory OAuth2, True Cache, Readable Per-PDB Standby, Sharding with active-active Raft-based replication, Automatic SQL Plan Management, Priority Transactions, SQL Syntax Simplification, Annotations, Data Usage Domains, Column Value Lock-free Reservations
Oracle Database 21c 21.1.0 December 2020 (cloud)[10]

August 2021 (Linux)[11]

Blockchain Tables, Multilingual Engine - JavaScript Execution in the Database, Binary JSON Data Type, Per-PDB Data Guard Physical Standby (aka Multitenant Data Guard), Per-PDB GoldenGate Change Capture, Self-Managing In-Memory, In-Memory Hybrid Columnar Scan, In-Memory Vector Joins with SIMD, Sharding Advisor Tool, Property Graph Visualization Studio, Automatic Materialized Views, Automatic Zone Maps, SQL Macros, Gradual Password Rollover
Oracle Database 19c 19.1.0 // 12.2.0.3 February 2019 (Exadata)[12]

April 2019 (Linux)[13]
June 2019 (cloud)

Active Data Guard DML Redirection, Automatic Index Creation, Real-Time Statistics Maintenance, SQL Queries on Object Stores, In-Memory for IoT Data Streams, Hybrid Partitioned Tables, Automatic SQL Plan Management, SQL Quarantine, Zero-Downtime Grid Infrastructure Patching, Finer-Granularity Supplemental Logging, Automated PDB Relocation
Oracle Database 18c 18.1.0 // 12.2.0.2 February 2018 (cloud, Exadata)[14]

July 2018 (other)[15]

18.17.0 January 2022 Polymorphic Table Functions, Active Directory Integration, Transparent Application Continuity, Approximate Top-N Query Processing, PDB Snapshot Carousel, Online Merging of Partitions and Subpartitions
Oracle Database 12c Release 2 12.2.0.1 August 2016 (cloud)

March 2017 (on-prem)

12.2.0.1 March 2017 Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer
Oracle Database 12c Release 1 12.1.0.1 July 2013[16] 12.1.0.2 July 2014 Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service
Oracle Database 11g Release 2 11.2.0.1 September 2009[17] 11.2.0.4 August 2013 Edition-Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance
Oracle Database 11g Release 1 11.1.0.6 September 2007 11.1.0.7 September 2008 Active Data Guard, Secure Files, Exadata
Oracle Database 10g Release 2 10.2.0.1 July 2005[18] 10.2.0.5 April 2010 Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-Start Failover, Transparent Data Encryption
Oracle Database 10g Release 1 10.1.0.2 2003 10.1.0.5 February 2006 Automated Database Management, Automatic Database Diagnostic Monitor, Grid infrastructure, Oracle ASM, Flashback Database
Oracle9i Database Release 2 9.2.0.1 2002 9.2.0.8 April 2007 Advanced Queuing, Data Mining, Streams, Logical Standby
Oracle9i Database 9.0.1.0 2001 9.0.1.5 December 2003 Oracle Real Application Clusters (RAC), Oracle XML DB
Oracle8i Database 8.1.5.0 1998 8.1.7.4 August 2000 Native internet protocols and Java, Virtual Private Database
Oracle8 Database 8.0.3 June 1997 8.0.6 Recovery Manager, Partitioning. First version available for Linux.[19]
Oracle 7.3 7.3.0 February 1996 7.3.4 Object-relational database
Oracle 7.2 7.2.0 May 1995 Shared Server, XA Transactions, Transparent Application Failover
Oracle 7.1 7.1.0 May 1994 Parallel SQL Execution. First version available for Windows NT.[20]
Oracle7 7.0.12 June 1992 PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost-Based Optimizer
Oracle 6.2 6.2.0 Oracle Parallel Server
Oracle v6 6.0.17 1988 6.0.37 Row-level locking, scalability, online backup and recovery, PL/SQL. First version available for Novell Netware 386.[21]
Oracle v5 5.0.22 (5.1.17) 1985 5.1.22 Support for client/server computing and distributed database systems. First version available for OS/2.[22]
Oracle v4 4.1.4.0 1984 4.1.4.4 Multiversion read consistency. First version available for MS-DOS.[23][24]
Oracle v3 3.1.3 1983 Concurrency control, data distribution, and scalability
Oracle v2 2.3 1979 First commercially available SQL-based RDBMS implementing some basic SQL queries and simple joins[25]
{{{2}}}

The Introduction to Oracle Database includes a brief history on some of the key innovations introduced with each major release of Oracle Database.

See My Oracle Support (MOS) note Release Schedule of Current Database Releases (Doc ID 742060.1) for the current Oracle Database releases and their patching end dates.

Patch updates and security alerts

Prior to Oracle Database 18c, Oracle Corporation released Critical Patch Updates (CPUs) and Security Patch Updates (SPUs)[26] and Security Alerts to close security vulnerabilities. These releases are issued quarterly; some of these releases have updates issued prior to the next quarterly release.

Starting with Oracle Database 18c, Oracle Corporation releases Release Updates (RUs) and Release Update Revisions (RURs).[27] RUs usually contain security, regression (bug), optimizer, and functional fixes which may include feature extensions as well. RURs include all fixes from their corresponding RU but only add new security and regression fixes. However, no new optimizer or functional fixes are included.

Market position

A 2016 Gartner report claimed to show Oracle holding #1 RDBMS market share worldwide based on the revenue share ahead of its four closest competitors – Microsoft, IBM, SAP and Teradata .[28][verification needed][clarification needed] A 2021 Gartner Magic Quadrant report named Oracle a leader in Cloud Database Management Systems.[29]

Competition

In the market for relational databases, Oracle Database competes against commercial products such as IBM Db2 and Microsoft SQL Server. Oracle and IBM tend to battle for the mid-range database market on Unix and Linux platforms, while Microsoft dominates the mid-range database market on Microsoft Windows platforms. However, since they share many of the same customers, Oracle and IBM tend to support each other's products in many middleware and application categories (for example: WebSphere, PeopleSoft, and Siebel Systems CRM), and IBM's hardware divisions work closely[citation needed] with Oracle on performance-optimizing server-technologies (for example, Linux on IBM Z). Niche commercial competitors include Teradata (in data warehousing and business intelligence), Software AG's ADABAS, Sybase, and IBM's Informix, among many others.

In the cloud, Oracle Database competes against the database services of AWS, Microsoft Azure, and Google Cloud Platform.

Increasingly, the Oracle database products compete against open-source software relational and non-relational database systems such as PostgreSQL, MongoDB, Couchbase, Neo4j, ArangoDB and others. Oracle acquired Innobase, supplier of the InnoDB codebase to MySQL, in part to compete better against open source alternatives, and acquired Sun Microsystems, owner of MySQL, in 2010. Database products licensed as open-source are, by the legal terms of the Open Source Definition, free to distribute and free of royalty or other licensing fees.

See also

References

  1. Lextrait, Vincent (March 2016). "The Programming Languages Beacon, v16". http://www.lextrait.com/Vincent/implementations.html. 
  2. "OTN Standard License", Technical network (Oracle), http://www.oracle.com/technetwork/licenses/standard-license-152015.html 
  3. "Multimodel Database with Oracle Database 12c Release 2". Oracle. http://download.oracle.com/otndocs/products/spatial/pdf/12c/Multimodel_Database_with_Oracle_Database_12c_Release_2.pdf. 
  4. "Exadata", Technical network (Oracle), http://www.oracle.com/technetwork/database/exadata/exacm-ds-3409774.pdf 
  5. Roeser, Mary Beth; Adams, Drew; Ashdown, Lance; Baby, Thomas; Baer, Hermann; Baskan, Yasin; Bayliss, Nigel; Chen, Shuo et al.. "Oracle and Standard SQL" (in en-US). https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Oracle-and-Standard-SQL.html. 
  6. "Welcome to Larryland". The Guardian. https://www.theguardian.com/g2/story/0,3604,215072,00.html. 
  7. Julie Bort (29 September 2014). "Larry Ellison Is A Billionaire Today Thanks to the CIA". http://www.businessinsider.com/the-cia-made-larry-ellison-a-billionaire-2014-9?international=true&r=US&IR=T. 
  8. "Oracle Database 23c Free - Developer Release" (in en). https://www.oracle.com/database/free. 
  9. "Oracle Database 23c on OCI Base Database Service" (in en). https://blogs.oracle.com/database/post/oracle-database-23c-the-next-long-term-support-release. 
  10. "Oracle Database 21c" (in en). https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html. 
  11. Hardie, William (23 September 2021). "Oracle Database 21c Now Available On Linux". https://blogs.oracle.com/database/post/oracle-database-21c-available-now-on-linux. 
  12. Giles, 1Dominic (2019-02-13). "Oracle Database 19c Now Available on Oracle Exadata". https://blogs.oracle.com/database/oracle-database-19c-now-available-on-oracle-exadata. 
  13. Hardie, William (2019-04-25). "Oracle Database 19c Now Available on Linux". https://blogs.oracle.com/database/oracle-database-19c-now-available-on-linux. 
  14. "Oracle Database 18c : Now available on the Oracle Cloud and Oracle Engineered Systems". 2018-02-16. https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems. 
  15. Zagar, Adriana (2018-07-23). "Oracle Database 18c Now Available For On-Premises". https://community.oracle.com/community/support/support-blogs/database-support-blog/blog/2018/07/23/oracle-database-18c-now-available-for-on-premises. 
  16. "Oracle Announces General Availability of Oracle Database 12c, the First Database Designed for the Cloud". 2013-07-01. http://www.oracle.com/us/corporate/press/1967380. 
  17. "Oracle® Database 11g Release 2 is Now Available". 2009-09-01. http://www.oracle.com/us/corporate/press/032365. 
  18. "Oracle Announces General Availability of Oracle® Database 10g Release 2". 2005-07-11. http://www.oracle.com/us/corporate/press/017324_EN. 
  19. Biggs, Maggie (1998-10-05). "Oracle8 on Linux shows promise". InfoWorld. https://books.google.com/books?id=sFEEAAAAMBAJ&pg=PA129. Retrieved 2019-09-07. 
  20. Nash, Kim (1994-10-03). "Oracle users ponder product overload". Infoworld (IDG Enterprise). https://books.google.com/books?id=IrCYpCv7YXsC&pg=PA7. Retrieved 2020-07-30. 
  21. O'Brien, Timothy (1991-04-29). "Oracle8 on Linux shows promise". InfoWorld. https://books.google.com/books?id=Gw0EAAAAMBAJ&pg=PA2. Retrieved 2019-09-07. 
  22. Mace, Scott (1989-01-30). "DOS Version of Professional Oracle 5.1B Adds SQL Report Writer". InfoWorld. https://books.google.com/books?id=MzoEAAAAMBAJ&pg=PA6. Retrieved 2019-09-07. 
  23. Webster, Robin (1984-11-13). "PC Relational Database? New Answer is Oracle". PC Magazine. https://books.google.com/books?id=-Ukz6hjZEA4C&pg=PA57. Retrieved 2019-07-01. 
  24. Gralike, Marco (2006-04-04). "Back to the future (Oracle 4.1 VM appliance)". https://technology.amis.nl/2006/04/04/back-to-the-future-oracle-41-vm-appliance/. 
  25. Departments of Informatics. "Oracle V2". University of Klagenfurt. http://cs-exhibitions.uni-klu.ac.at/index.php?id=403. 
  26. Baransel, Emre (2013). Oracle Data Guard 11gR2 Administration Beginner's Guide. Packt Publishing Ltd. ISBN 9781849687911. https://books.google.com/books?id=bnx9_MkBimcC. Retrieved 2014-01-15. "You should not get confused between Critical Patch Update (CPU) and Security Patch Update (SPU) as CPU terminology has been changed to SPU from October 2012." 
  27. "Patch Delivery Methods for Oracle Database 12c Release 2 (12.2.0.1) and Later Versions". Docs.oracle.com. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbptc/patch-delivery-methods-for-oracle-database-12c-release-2-12-2-0-1-and-later-versions-243888991.html. Retrieved 2022-03-16. 
  28. Heudecker, Nick; Feinberg, Donald; Adrian, Merv (July 25, 2017). "State of the Operational DBMS Market, 2017". https://www.gartner.com/doc/3769150. 
  29. "Magic Quadrant for Cloud Database Management Systems" (in en). https://www.gartner.com/en/documents/4009286. 

External links